How to: Create an embedded chart.
Solution:
Select the desired data from which to create a chart. Select 'Chart' from the 'Insert' menu and select 'On This Sheet'. Specify the location and the size of the chart and follow the instructions displayed by the Chart Wizard.
1) Open the desired workbook.
2) Click the tab for the worksheet that contains the desired data and where the new chart should appear.
3) Select the rows and/or columns to chart, including any label text.
4) Select the 'Insert' menu and select 'Chart'. (A submenu appears.)
5) Select 'On This Sheet' from the submenu. (The pointer changes to a plus sign with a tiny column chart.)
NOTE: Clicking 'ChartWizard' on the 'Standard toolbar' also creates the same result.
ChartWizard button
6) Draw the area where the chart should appear on the worksheet.
a) Place the pointer on one corner of the desired area:
b) Press and hold down the mouse button.
c) Drag the pointer to draw the size of the chart area.
d) Release the mouse button when the desired size is reached. (The ChartWizard - Step 1 of 5 dialog box appears.)
the ChartWizard - Step 1 of 5 dialog box
7) Make sure the range in the 'Range' box of the displayed dialog box is correct.
NOTE: The range in the 'Range' box defaults to the data selected in Step 3).
8) Click 'Next'. (The ChartWizard - Step 2 of 5 dialog box appears.)
the ChartWizard - Step 2 of 5 dialog box
9) Select the desired chart type from the 'Select a chart type' box.
10) Click 'Next'. (The ChartWizard - Step 3 of 5 dialog box appears.)
the ChartWizard - Step 3 of 5 dialog box
11) Select the desired format for the chart from the 'Select a format for the <x> chart' box, where <x> stands for the type of chart selected in Step 9).
12) Click 'Next'. (The ChartWizard - Step 4 of 5 dialog box appears with a sample chart that uses the selected data.)
the ChartWizard - Step 4 of 5 dialog box
13) Make sure that the sample chart correctly presents the selected data.
14) (Optional) To change the data presentation, do one or more of the following:
a) Change to the other option in the 'Data Series in' group.
b) Specify the row containing the text to use as the X-axis labels in the 'Category (X)' box.
c) Specify the column containing the text to use as the Y-axis labels in the 'Value (Y)' box.
15) Click 'Next'. (The ChartWizard - Step 5 of 5 dialog box appears.)
the ChartWizard - Step 5 of 5 dialog box
NOTE: The sample chart in this dialog box incorporates any changes made in the previous dialog box.
16) (Optional) Specify whether to add a legend to the chart in the 'Add a Legend?' group.
NOTE: Any additions or changes made in the dialog box are immediately reflected in the sample chart.
17) (Optional) Type a title for the chart in the 'Chart Title' box.
18) (Optional) Type a title for the X-axis in the 'Category (X)' box of the 'Axis Titles' group.
19) (Optional) Type a title for the Y-axis in the 'Value (Y)' box of the 'Axis Titles' group.
20) Click 'Finish'. (A chart appears in the worksheet.)
21) (Optional) Resize the chart so that it appears properly.
